﻿CREATE PROCEDURE [dbo].[Bowlers_SelectByLeagueId]
   @league_id uniqueidentifier
AS
  SELECT [dbo].[Bowlers].[bowler_id],
         [dbo].[Bowlers].[last_name],
         [dbo].[Bowlers].[first_name],
         [dbo].[Bowlers].[nick_name]
    FROM [dbo].[Bowlers]
         INNER JOIN [dbo].[League_Members]
                    ON [dbo].[Bowlers].[bowler_id] = [dbo].[League_Members].[bowler_id]
   WHERE [dbo].[League_Members].[league_id] = @league_id


